Ask user to update automatic links instead of automatically updating spreadsheet

Ask user to update automatic links instead of automatically updating spreadsheet - Excel.

Overview

Finding ID	Version	Rule ID	IA Controls	Severity
V-17732	DTOO150 - Excel	SV-18908r1_rule	ECSC-1	Medium

Description
If an Excel 2007 workbook contains links to other documents and users are not prompted to approve them, the contents of the workbook might change without the users' knowledge because the linked files have changed. By default, users are prompted to update automatic links.

STIG	Date
Microsoft Excel 2007	2015-10-02

Details

Check Text ( C-18998r1_chk )
The policy value for User Configuration -> Administrative Templates -> Microsoft Office Excel 2007 -> Excel Options -> Advanced “Ask to update automatic links” will be set to “Enabled”. Procedure: Use the Windows Registry Editor to navigate to the following key: HKCU\Software\Policies\Microsoft\Office\12.0\Excel\Options\BinaryOptions Criteria: If the value fUpdateExt_78_1 is REG_DWORD = 0, this is not a finding.

Check Text ( C-18998r1_chk )

The policy value for User Configuration -> Administrative Templates -> Microsoft Office Excel 2007 -> Excel Options -> Advanced “Ask to update automatic links” will be set to “Enabled”.

Procedure: Use the Windows Registry Editor to navigate to the following key:

HKCU\Software\Policies\Microsoft\Office\12.0\Excel\Options\BinaryOptions

Criteria: If the value fUpdateExt_78_1 is REG_DWORD = 0, this is not a finding.

Fix Text (F-17632r1_fix)
The policy value for User Configuration -> Administrative Templates -> Microsoft Office Excel 2007 -> Excel Options -> Advanced “Ask to update automatic links” will be set to “Enabled”.